using System;
using System.Collections.Generic;
using System.Text;
using System.Data.Sql;
using System.Data.SqlClient;
using System.Data;
namespace DataAccessLayer
{
    public  class Symptom
    {
        private string SymtomName;
        private string Description;
        private string connstring;

       public Symptom(string connstring)
        {
             this.connstring = connstring;
        }
        public string SNAME
        {
            get { return SymtomName; }
            set { SymtomName = value; }
        }
        public string DESCRP
        {
            get { return Description; }
            set { Description = value; }
        }
        public DataTable sShow()
        {
            SqlDataReader s1 = null;
            SqlConnection con = new SqlConnection(connstring);
            con.Open();
            SqlCommand cmd = new SqlCommand();
            cmd.Connection = con;
            cmd.CommandText = "SShow";
            cmd.CommandType = CommandType.StoredProcedure;
            s1 = cmd.ExecuteReader();
            DataTable dtDisplay = new DataTable();
            dtDisplay.Load(s1);
            con.Close();
            return dtDisplay;
       }
   }
}
